#common-excel 模块使用

public class UserExcelVO {

	@ExcelProperty("用户编号")
	private Integer userId;

	@NotBlank(message = "用户名不能为空")
	@ExcelProperty("用户名")
	private String username;
}

@ResponseExcel
@GetMapping("/export")
public List<UserExcelVO> export(UserDTO userDTO) {
  return userService.listUser(userDTO);
}

@PostMapping("/import")
public R importUser(@RequestExcel List<UserExcelVO> excelVOList, BindingResult bindingResult) {
  return userService.importUser(excelVOList, bindingResult);
}

List<ErrorMessage> errorMessageList = (List<ErrorMessage>) bindingResult.getTarget();

if (CollUtil.isNotEmpty(errorMessageList)) {
  return R.failed(errorMessageList);
}

@Data
public class User {
    private Long id;
    private String username;
    private Integer gender;  // 数据库存储: 0-女,1-男
    private Integer status;  // 数据库存储: 1-启用,0-禁用
}

@Data
public class UserExcelDTO {
    @ExcelProperty("用户ID")
    private Long id;

    @ExcelProperty("用户名")
    private String username;

    @ExcelProperty("性别")
    private String genderName;  // Excel中显示: 男/女

    @ExcelProperty("状态")
    private String statusName;  // Excel中显示: 启用/禁用
}

public List<UserExcelDTO> convertToExcelDTO(List<User> users) {
    return users.stream()
        .map(user -> {
            UserExcelDTO dto = new UserExcelDTO();
            dto.setId(user.getId());
            dto.setUsername(user.getUsername());

            // 性别转换
            dto.setGenderName(user.getGender() == 1 ? "男" : "女");

            // 状态转换
            dto.setStatusName(user.getStatus() == 1 ? "启用" : "禁用");

            return dto;
        })
        .collect(Collectors.toList());
}